create table test (id UInt64, json JSON(max_dynamic_paths=3)) engine=MergeTree order by id settings min_rows_for_wide_part=1000000000, min_bytes_for_wide_part=10000000000, vertical_merge_algorithm_min_columns_to_activate=1;
Dynamic paths
100000	a
90000	b
80000	c
70000	d
60000	e
Shared data paths
Dynamic paths
100000	a
90000	b
80000	c
Shared data paths
70000	d
60000	e
Dynamic paths
200000	f
100000	a
90000	b
80000	c
Shared data paths
70000	d
60000	e
Dynamic paths
200000	f
100000	a
90000	b
Shared data paths
80000	c
70000	d
60000	e
Dynamic paths
200000	f
100000	a
90000	b
10000	g
Shared data paths
80000	c
70000	d
60000	e
Dynamic paths
200000	f
100000	a
90000	b
Shared data paths
80000	c
70000	d
60000	e
10000	g
Dynamic paths
200000	f
100000	a
90000	b
40000	c
Shared data paths
80000	c
70000	d
60000	e
10000	g
Dynamic paths
200000	f
120000	c
100000	a
Shared data paths
90000	b
70000	d
60000	e
10000	g
create table test (id UInt64, json JSON(max_dynamic_paths=3)) engine=MergeTree order by id settings min_rows_for_wide_part=1, min_bytes_for_wide_part=1, vertical_merge_algorithm_min_columns_to_activate=1;
Dynamic paths
100000	a
90000	b
80000	c
70000	d
60000	e
Shared data paths
Dynamic paths
100000	a
90000	b
80000	c
Shared data paths
70000	d
60000	e
Dynamic paths
200000	f
100000	a
90000	b
80000	c
Shared data paths
70000	d
60000	e
Dynamic paths
200000	f
100000	a
90000	b
Shared data paths
80000	c
70000	d
60000	e
Dynamic paths
200000	f
100000	a
90000	b
10000	g
Shared data paths
80000	c
70000	d
60000	e
Dynamic paths
200000	f
100000	a
90000	b
Shared data paths
80000	c
70000	d
60000	e
10000	g
Dynamic paths
200000	f
100000	a
90000	b
40000	c
Shared data paths
80000	c
70000	d
60000	e
10000	g
Dynamic paths
200000	f
120000	c
100000	a
Shared data paths
90000	b
70000	d
60000	e
10000	g
